//dataSource {
//    pooled = true
//    driverClassName = "org.hsqldb.jdbcDriver"
//    username = "sa"
//    password = ""
//}
hibernate {
    cache.use_second_level_cache = true
    cache.use_query_cache = true
    cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider'
}
// environment specific settings
environments {
    development {
        dataSource {
          pooled = true
          driverClassName = "org.postgresql.Driver"
          username = "root"
          password = "password"
            dbCreate = "update" // one of 'create', 'create-drop','update'
            url = "jdbc:postgresql://localhost/sa-dept-test"
        }
    }
    test {
      dataSource {
        pooled = true
        driverClassName = "org.postgresql.Driver"
        username = "postgres"
        password = "password"
          dbCreate = "create-drop" // one of 'create', 'create-drop','update'
          url = "jdbc:postgresql://solarch/portico"
      }
    }
  production {
      dataSource {
        pooled = true
        driverClassName = "org.postgresql.Driver"
        username = "postgres"
        password = "password"
          dbCreate = "update" // one of 'create', 'create-drop','update'
          url = "jdbc:postgresql://solarch/sadeptdb"
      }
  }

}
